﻿create PROCEDURE [dbo].[proc_ManagementArea_GetItem_zzjg]
	(
		@Id int
	)
AS
	Select ma.Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,
	ContactPerson,ContactPhone,ContactEmail,WebAddress,Products,zid
	 From ManagementArea ma,zzjg z Where z.Id=@Id AND ma.zid=z.bh
	RETURN
